
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchRecruitmentByTypeCompany]
	(
	@param_type NVarChar(100)
	)
AS
	/* SET NOCOUNT ON */
	Select * from dbo.JOL_Recruitment where type =@param_type and state='True' AND getdate()<= dateadd(day,7,end_time)  ORDER BY update_time,add_time DESC
	RETURN
GO
